package com.jkoss.dao.jy;

import com.jkoss.pojo.jy.Stucmpjob;
import com.jkoss.pojo.jy.StucmpjobExample;
import com.jkoss.tool.Page;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;

public interface StucmpjobMapper {
	
	@Select("SELECT  a.*, b.jyname ,c.ename from t_stu_cmpjob a,t_jiuyecomps b,t_emps c "
			+ "where a.jyid=b.jyid and a.eid=c.eid")
	@ResultMap("com.jkoss.dao.jy.StucmpjobMapper.BaseResultMap2")
	List<Stucmpjob> listPageGw(Page<Stucmpjob> page);
	
	@Select("SELECT  a.*, b.jyname ,c.ename from t_stu_cmpjob a,t_jiuyecomps b,t_emps c "
			+ "where a.jyid=b.jyid and a.eid=c.eid  and a.jygwid=${jygwid}")
	@ResultMap("com.jkoss.dao.jy.StucmpjobMapper.BaseResultMap2")
	Stucmpjob findByGwId(@Param("jygwid") Integer jygwid);
	
	@Select("SELECT  a.jygwid, a.jygwName, b.jyname  from t_stu_cmpjob a,t_jiuyecomps b where a.jyid=b.jyid")
	@ResultMap("com.jkoss.dao.jy.StucmpjobMapper.BaseResultMap2")
	List<Stucmpjob> listGwAndCp();
	
	
	int countByExample(StucmpjobExample example);

    int deleteByExample(StucmpjobExample example);

    int deleteByPrimaryKey(Integer jygwid);

    int insert(Stucmpjob record);

    int insertSelective(Stucmpjob record);

    List<Stucmpjob> selectByExample(StucmpjobExample example);

    Stucmpjob selectByPrimaryKey(Integer jygwid);

    int updateByExampleSelective(@Param("record") Stucmpjob record, @Param("example") StucmpjobExample example);

    int updateByExample(@Param("record") Stucmpjob record, @Param("example") StucmpjobExample example);

    int updateByPrimaryKeySelective(Stucmpjob record);

    int updateByPrimaryKey(Stucmpjob record);

	

	

	
}